﻿


-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		09/25/2010 1.0
-- =========================================================================================================
CREATE PROCEDURE [flcr].[api_service_device_xref_sel_lov]
@SERVICE_DEVICE_XREF_ID INT

AS
BEGIN
  
	SELECT	[SERVICE_DEVICE_XREF_ID]
	  FROM	[FLCR].[SERVICE_DEVICE_XREF] 
     WHERE	[SERVICE_DEVICE_XREF_ID] = COALESCE(@SERVICE_DEVICE_XREF_ID,[SERVICE_DEVICE_XREF_ID])


END
